NYC Traffic Accidents

Motor vehicle collisions reported by the New York City Police Department from January-August 2020. Each record represents an individual collision, including the date, time and location of the accident (borough, zip code, street name, latitude/longitude), vehicles and victims involved, and contributing factors.

Data Source : https://www.mavenanalytics.io/data-playground

----Load data----

---- Start the data cleaning----

We need to make sure the data is clean before starting your analysis. As a reminder, we should check for:

Duplicate Records

How many duplicate transaction records are there?

Drop Duplicate Records

Drop the duplicated records.

Consistent formatting

Missing Values

How many missing values are there?

Rename column name

Data cleaning finished!! 👏 Now! We are ready to answer questions and draw conclusions using our data. 👌 🍀

----Finish the data cleaning----

Time analysis

How many accidents were registered by the police in New York City in 2020 by date?

Number of accident per date (Jan-Aug 2020)